J Tech ✭✭✭✭✭

Overview

Overview

Roles	No Roles
Badges	27

About Me

About Me

Not much happening here, yet.

Analytics

74

Posts

120

Visits

9.8k

Points

Aug 17, 2015

Join Date

Jan 15, 2025

Last Active

Reactions

• Insightful 4

  4
• Vote Up 7

  7
• Awesome 4

  4

• Activity
• Discussions12
• Comments62

• Rank Function

  J Tech

  12/17/20
  Hi, How do I create a rank formula for the field, that only includes certain values from a row that meets certain criteria. For example the below image is the example. I only want to rank and include…
  1 ·

• Re: IF(AND - Error, Unparseable

  J Tech

  03/17/23
  Hi @Holli, It looks like there's a syntax error in your combined formula. Try this instead: =IF(AND([Pay Schedule]@row = "GA-Full Session", [Hrs Per Period]@row = "5"), 160, IF(AN…
  1 ·

• Re: Need to look across multiple sheets, to match the name and then return the information within a cell

  J Tech

  03/20/23
  Hi @HollywoodStu For example, to search across 9 different sheets for the Wider Project Costs and return the matching value in the 'Submitted Wider Project Costs' column, you could use the following …
  1 ·

• Re: Sumifs with multiple criteria's in a single row

  J Tech

  03/16/23
  Hi @Benny Velazquez, Jumping in to help! Yes, it's possible to count the correct answers on a single row across multiple criteria. You can use the SUM function in combination with multiple IF stateme…
  1 ·